<?php
/**
 * BroadcasterSubscriberFixture
 *
 */
class BroadcasterSubscriberFixture extends CakeTestFixture {

/**
 * Fields
 *
 * @var array
 */
	public $fields = array(
		'id' => array('type' => 'integer', 'null' => false, 'default' => null, 'key' => 'primary'),
		'broadcaster_id' => array('type' => 'integer', 'null' => false, 'default' => null, 'key' => 'primary'),
		'broadcaster_keyword_id' => array('type' => 'integer', 'null' => false, 'default' => null, 'key' => 'primary'),
		'sub_number' => array('type' => 'integer', 'null' => false, 'default' => null),
		'sub_email' => array('type' => 'string', 'null' => true, 'default' => null, 'length' => 100, 'collate' => 'utf8_general_ci', 'charset' => 'utf8'),
		'sub_date' => array('type' => 'date', 'null' => true, 'default' => null),
		'unsub_date' => array('type' => 'date', 'null' => true, 'default' => null),
		'sub_status' => array('type' => 'integer', 'null' => false, 'default' => '1'),
		'auto_unsub_date' => array('type' => 'date', 'null' => true, 'default' => null),
		'abuse_flag' => array('type' => 'integer', 'null' => true, 'default' => null),
		'sub_pin' => array('type' => 'integer', 'null' => true, 'default' => null),
		'indexes' => array(
			'PRIMARY' => array('column' => array('id', 'broadcaster_id', 'broadcaster_keyword_id'), 'unique' => 1),
			'fk_ad_cloud_subs_ad_cloud1' => array('column' => array('broadcaster_id', 'broadcaster_keyword_id'), 'unique' => 0),
			'broadcaster_keyword_id' => array('column' => 'broadcaster_keyword_id', 'unique' => 0)
		),
		'tableParameters' => array('charset' => 'utf8', 'collate' => 'utf8_general_ci', 'engine' => 'InnoDB')
	);

/**
 * Records
 *
 * @var array
 */
	public $records = array(
		array(
			'id' => 1,
			'broadcaster_id' => 1,
			'broadcaster_keyword_id' => 1,
			'sub_number' => 1,
			'sub_email' => 'Lorem ipsum dolor sit amet',
			'sub_date' => '2012-07-30',
			'unsub_date' => '2012-07-30',
			'sub_status' => 1,
			'auto_unsub_date' => '2012-07-30',
			'abuse_flag' => 1,
			'sub_pin' => 1
		),
	);

}
